[ROOT]  dt  FactInternetSale  WHERE DimCurrency.AlternateKey EQ 'AUD'  >   PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount   ORDER BY 2020 DESC  >   <  TAKE 250  >   TITLE Top 1000 Australian Internet customers for 2020   

Top 1000 Australian Internet customers for 2020

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Ramos, Marie, A,143085140.400.000.002805.432334.97
Lal, Karl, R,142645217.730.000.002822.762394.97
Ross, Arianna, E,267741331.970.000.001331.970.00
Serrano, Mallory, E,267511903.480.000.00782.991120.49
Zimmerman, Candice, J,267541938.470.000.00782.991155.48
Shan, Bridget,2933839.980.000.0039.980.00
Kumar, Tasha, M,202495333.250.003578.271754.980.00
Yuan, Bethany, G,110306471.323399.990.002319.99751.34
Goel, Karl,1870559.260.000.0059.260.00
Liu, Omar, L,122523938.950.003374.99563.960.00
Martin, Diane,139586838.640.002049.102405.472384.07
Sai, Ronald, B,136436799.450.002071.422334.972393.06
Chander, Dustin,118958149.040.003374.994774.050.00
Ashe, Maurice,204306056.610.003578.272478.340.00
Ramos, Briana, J,143033636.910.000.002894.56742.35
Washington, Abigail,236613961.030.000.002181.561779.47
Alexander, Olivia, L,146675295.410.000.002049.103246.31
Luo, Christine, J,241592756.540.000.002756.540.00
Lin, Sandra, A,250522155.920.000.002155.920.00
Li, Gilbert,239992730.540.000.002730.540.00
Wang, Kelvin, S,151434366.410.000.002071.422294.99
Lopez, Virginia, J,273381339.920.000.001339.920.00
Miller, Zachary, M,151692919.890.000.002071.42848.47
Guo, Micah, M,241632756.540.000.002756.540.00
Howard, Jesse, D,242492756.540.000.002181.56574.98
Ye, Alejandro, W,150293826.400.000.003826.400.00
Luo, Colleen, E,152082951.560.000.002049.10902.46
Luo, Kenneth, S,152112910.900.000.002071.42839.48
Suarez, Meredith,150323800.080.000.003800.080.00
Perez, Dominique,1234468.700.000.0068.700.00
Taylor, Christopher, E,2117137.290.000.0037.290.00
Ashe, Misty, R,231294.990.000.004.990.00
Guo, Autumn, A,1421386.260.000.0058.9827.28
Simmons, Jacqueline, W,13137177.940.000.00177.940.00
Cai, Bianca, D,221732735.530.002181.56553.970.00
Rana, Raymond,251152155.920.000.002155.920.00
Ma, Roger, V,151305215.400.000.002049.103166.30
Suri, Jillian, L,151804466.390.000.002071.422394.97
Hernandez, Jaime,241703018.330.000.002443.35574.98
Chander, Drew, J,251112145.920.000.002145.920.00
Hernandez, Jessie, A,241722735.530.000.002181.56553.97
Martinez, Lydia,241692735.530.000.002181.56553.97
Browning, Jay, M,242512983.340.000.002443.35539.99
Xu, Jaclyn,242522744.520.000.002181.56562.96
Kumar, Derek, M,151354381.390.000.002071.422309.97
Alvarez, Tabitha,150283826.400.000.003826.400.00
Raman, Meagan, J,151345151.710.000.002071.423080.29
Zheng, Jeffery, W,150303786.390.000.003786.390.00
Yang, Cedric,150383750.090.000.002049.101700.99
Xu, Shawna,2341939.980.000.000.0039.98
Xu, Glenn,1874367.210.000.0056.9710.24
Rubio, Nelson,264331903.480.00782.990.001120.49
Zheng, Kristen, J,244633917.540.000.002181.561735.98
Sanz, Victor,172954392.743578.270.000.00814.47
Sara, Clifford, M,241782810.530.000.002181.56628.97
Raman, Ruben,155802910.900.000.002071.42839.48
Bhat, Yolanda,152254401.410.000.002071.422329.99
Ye, Alvin, B,155752910.900.000.002071.42839.48
Andersen, Gilbert, T,273531371.950.000.001371.950.00
Gonzalez, Natalie,252152155.920.000.002155.920.00
Martin, Ebony, F,152234366.410.000.002071.422294.99
Navarro, Leslie, E,243714193.820.000.002443.351750.47
Malhotra, Harold,152274469.560.000.002049.102420.46
Zhou, Clayton,273481382.460.000.001382.460.00
Russell, Seth,251382120.930.000.002120.930.00
Torres, Marc,117658143.030.003374.994768.040.00
Pal, Jenny,15132151.940.000.0092.9658.98
Hu, Cara,206086035.600.003578.272457.330.00
Kennedy, Devon, J,131336813.120.002049.102344.962419.06
Arun, Brenda,136306824.730.002071.422369.242384.07
Hernandez, Ebony, S,235743337.040.000.003337.040.00
Becker, Leonard, C,22405123.980.000.00123.980.00
Hu, Lacey,199486021.620.003578.272443.350.00
Hernandez, Jill, L,13003230.250.000.00230.250.00
Smith, Tina, K,197936056.610.003578.272478.340.00
Mehta, Denise,130806844.410.002049.102362.272433.04
Martinez, Holly, B,196286035.600.003578.272457.330.00
Nara, Cassie,1364279.970.000.0079.970.00
Huang, Micah,251307.280.000.007.280.00
Carlson, Tanya,1618331.270.000.0031.270.00
Sanz, Nelson, M,1405649.480.000.0049.480.00
Sai, Tina, L,154253772.410.000.002071.421700.99
Rana, Henry,273421348.460.000.001348.460.00
Jiménez, Alberto, C,152154468.560.000.002049.102419.46
Fernandez, Donald, C,244623617.830.000.003617.830.00
Ward, Jessica,155874423.380.000.002071.422351.96
Jimenez, Jimmy,273651371.950.000.001371.950.00
Madan, Roy,157164467.060.000.002049.102417.96
Alvarez, Kendra, R,152672853.580.000.002049.10804.48
Jimenez, Teresa, L,243723356.040.000.003356.040.00
Price, Trevor, M,157254416.380.000.002071.422344.96
Blanco, Victor,155864469.370.000.002071.422397.95
He, Gilbert,155894416.380.000.002071.422344.96
Cai, Jeffery, A,155822907.560.000.002049.10858.46
Anand, Chad,244843563.840.000.003563.840.00
Guo, Cedric, R,274871322.980.000.00782.99539.99
Zhang, Edwin,157854454.350.000.002071.422382.93
Munoz, Sheila,274881322.980.000.00782.99539.99
Martin, Natasha, N,274901331.970.000.00782.99548.98
Sun, Jorge,160253831.890.000.002071.421760.47
Munoz, Natasha, M,246013882.550.000.002181.561700.99
Ms., Sherwood, Irma, J.,245984228.310.000.002443.351784.96
Jiménez, Byron,160263804.080.000.002049.101754.98
He, Omar,158312646.360.000.002646.360.00
Vazquez, Anne,160273826.400.000.002071.421754.98
Ramos, Leslie,157334443.550.000.002049.102394.45
Li, Margaret,157534399.080.000.002049.102349.98
Hernandez, Erika,161602644.070.000.002644.070.00
Torres, Monique,252352155.920.000.001000.441155.48
Muñoz, Jaime, C,245063563.840.000.003563.840.00
Alonso, Diana, L,245903911.530.000.002181.561729.97
Moore, Olivia, A,252312189.900.000.002189.900.00
Zhang, Kristen,274841322.980.000.00782.99539.99
Lin, Clayton, M,274921344.910.000.00782.99561.92
Martinez, Jay,245923896.530.000.002181.561714.97
Rai, Tonya,252432155.920.000.002155.920.00
Zhou, Autumn, L,252292155.920.000.002155.920.00
Carlson, Shannon, C,110098091.333374.990.004716.340.00
Carlson, Robin,197866021.620.003578.272443.350.00
Ruiz, Kari, L,12695192.970.000.00159.0033.97
Henderson, Xavier, K,1299396.250.000.0096.250.00
Beck, Derek,1732285.480.000.0085.480.00
Arun, Barry,2770039.980.000.0039.980.00
Ramos, Roy, A,244823882.550.000.002181.561700.99
Dominguez, Raquel, A,274701371.950.000.00782.99588.96
Alonso, Naomi,158302680.380.000.002680.380.00
Patel, Abby,160293807.400.000.002071.421735.98
Prasad, George, C,157674379.090.000.002049.102329.99
Goldberg, Mindy,161594411.650.000.002071.422340.23
Ashe, Brad,252282120.930.000.002120.930.00
Deng, Gilbert, C,157654369.090.000.002049.102319.99
Davis, Seth, A,163393169.590.000.003169.590.00
Kumar, Bridget,158024444.070.000.002049.102394.97
Lal, Alicia,157344426.410.000.002071.422354.99
Zeng, Warren, R,244773302.050.000.003302.050.00
Garcia, Preston, M,246023882.550.000.002181.561700.99
Zhu, Alisha, G,182396030.613578.270.002452.340.00
Campbell, Jason, J,136256962.140.002049.102439.992473.05
Cai, Trisha,1826564.980.000.000.0064.98
Mr., Shakespear, Paul, J.,173264467.763578.270.000.00889.49
Liang, Brittney, R,261826.280.000.000.006.28
Garcia, Toni,221934886.700.002443.350.002443.35
Lopez, Pamela, E,264441938.710.00782.990.001155.72
Mr., Solanki, Ajay,18295144.270.000.00144.270.00
Hu, Kristen, C,197886056.610.003578.272478.340.00
Gomez, Arthur,249172179.910.001000.441179.470.00
Coleman, Melanie, H,1563934.570.000.0034.570.00
Nara, Latoya, J,182086035.603578.270.002457.330.00
King, Maria, E,282022419.060.000.002419.060.00
Alvarez, Kari, C,111088124.043374.990.004749.050.00
Townsend, Darren,184675279.263578.270.001700.990.00
Anderson, Blake,110768159.043399.990.004759.050.00
Wang, Shannon,110176434.313374.990.002316.97742.35
Verhoff, Rob,110088106.313374.990.004731.320.00
Kapoor, Summer,28353548.980.000.00548.980.00
Alonso, Teresa,1313883.970.000.0083.970.00
Sai, Martin, L,2122129.990.000.0029.990.00
Wu, Alisha,2365459.980.000.0059.980.00
Chander, Misty,1733380.940.000.008.9971.95
Lal, Corey, H,233132906.030.002181.56724.470.00
Blanco, Billy,233162835.020.002181.56653.460.00
Navarro, Teresa, E,258167.280.000.007.280.00
Ashe, Briana,229404207.320.002443.351763.970.00
Wood, Sydney,233103333.320.002181.561151.760.00
Garcia, Rebekah, M,140073772.410.002071.421700.990.00
Prasad, Gerald, B,1203581.240.000.0081.240.00
Tang, Sharon, M,1582367.960.000.0028.9838.98
Black, Michele,1399564.970.000.0034.9929.98
Hu, Crystal,2798029.480.000.0029.480.00
Nara, Cristina, R,197926056.610.003578.272478.340.00
Raji, Willie, T,110708165.553399.990.004765.560.00
Saunders, Micheal,175134260.243578.270.00681.970.00
Chande, Lindsay,182446021.623578.270.002443.350.00
Liu, Jaclyn,129966808.150.002049.102374.982384.07
Huang, Amy, C,12244114.960.000.00114.960.00
Alexander, Gail, C,14682138.450.000.0088.4649.99
Moreno, Dwayne, T,2310385.480.000.0085.480.00
Gill, Mallory, P,16698197.880.000.00197.880.00
Navarro, Casey,197956044.590.003578.272466.320.00
Browning, Javier,231204144.340.002443.351700.990.00
Goel, Barbara,129886915.440.002049.102482.272384.07
Munoz, Shannon, S,2912249.970.000.0049.970.00
Hernandez, Alberto, D,250292272.200.001000.441271.760.00
Suri, Lydia,131266815.080.002049.102364.972401.01
Ortega, Janet, L,117548163.533399.990.004763.540.00
Prasad, Harold,1960868.450.000.0068.450.00
Zheng, Arturo, C,1146747.920.000.0024.9922.93
Li, Jack, J,140715617.920.002049.103568.820.00
Yang, Stacey,142155665.890.002049.103616.790.00
Saunders, Ruben, G,27983539.990.000.000.00539.99
Carson, Terrence,113565069.293374.990.00902.98791.32
Subram, Stefanie,12371214.040.000.00122.2991.75
Diaz, Mallory, V,17289106.950.000.0043.9762.98
Guo, Ernest,257171274.08699.100.000.00574.98
Perez, Cesar, L,27982603.490.000.000.00603.49
Liu, Glenn,188994118.263578.270.00539.990.00
Romero, Lawrence, C,166876070.593578.270.002492.320.00
Chande, Jaclyn, S,186985314.253578.270.001735.980.00
Long, Isabelle, W,231043490.030.002181.561308.470.00
Subram, Tabitha, C,175114150.533578.270.00572.260.00
Torres, Mathew, L,189004132.243578.270.00553.970.00
Lopez, Heidi,110528131.323374.990.004756.330.00
Malhotra, Stanley, H,114538176.983374.990.004801.990.00
Pal, Christine, I,182426121.713578.270.002543.440.00
Harris, Eduardo, S,182386030.613578.270.002452.340.00
Rana, Whitney, A,130066762.150.002049.102319.992393.06
Ray, Bobby,235753302.050.002181.561120.490.00
Ortega, Danny, K,197946098.580.003578.272520.310.00
Luo, Johnny,213593032.310.002443.35588.960.00
Andersen, Carl, J,110578088.043374.990.004713.050.00
Shan, Yolanda,127026911.100.002049.102388.962473.04
Shen, Nichole,129996840.460.002071.422349.982419.06
Martinez, Kari,196096093.200.003578.272514.930.00
Sun, Louis, E,1618283.970.000.0058.9824.99
Mehta, Mayra,129985694.900.002049.101249.842395.96
Sai, Abby, L,111018262.523399.990.004862.530.00
Sanz, Arthur,27688166.280.000.00166.280.00
Zhang, Barbara,16338169.430.000.00169.430.00
Ms., Rousey, Linda, R.,212794.990.000.004.990.00
Nath, Jaime,110336495.293374.990.002354.98765.32
Foster, Madison,140386819.120.002049.102376.962393.06
Butler, Elijah, D,2155129.990.000.0029.990.00
Perez, Janelle,16172186.040.000.0094.4691.58
Tang, Louis, A,1829239.250.000.0036.962.29
Martin, Gerald, K,1728490.250.000.0090.250.00
Gutierrez, Orlando,259201819.590.00699.101120.490.00
Raje, Jodi, E,1963074.450.000.0074.450.00
Kapoor, Pedro, H,242297.280.000.007.280.00
Lin, Ronnie, D,213842921.020.002181.56739.460.00
Sanz, Marvin,196126029.573578.270.002451.300.00
Alvarez, Mathew, L,17494111.960.000.00111.960.00
Ma, Jorge, O,1405286.260.000.0086.260.00
Hu, Aimee, R,2798139.980.000.0039.980.00
Gonzalez, Veronica, C,233113337.040.002181.561155.480.00
Deng, Kurt, D,13635215.740.000.0032.27183.47
Travers, Danny,1258777.270.000.000.0077.27
Kelly, Zoe,2312339.980.000.000.0039.98
Chande, Tracy, J,125882639.080.002049.100.00589.98
Townsend, Larry, D,111344911.833399.990.00769.49742.35
Prasad, Brandy, P,1400963.970.000.000.0063.97
Zhang, Susan, S,1821638.920.000.008.9929.93
Serrano, Marvin, E,1731697.450.000.000.0097.45
Shen, Grant, B,267631957.470.000.00782.991174.48
Gomez, Adrienne,119208156.320.003374.992362.272419.06
Jimenez, Naomi,249222145.920.001000.441145.480.00
Raman, Brandy,1224777.270.000.0077.270.00
Shen, Jodi, A,2202869.990.000.0069.990.00
Lu, Sandra, N,135214514.770.002071.422443.350.00
Sun, Clayton,285334.990.000.004.990.00
Nara, Sharon,184826030.613578.270.002452.340.00

Generated 2024-06-12 15:07:39.094 UTC